# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月12日
"""
import pandas as pd

path = '../数据文件/课件020/多层索引.xlsx'
data = pd.read_excel(path, sheet_name='有序')
# 省略index_col=[0,1]
data = data.set_index(['班级', '学号'])


print(data)